package com.cqc.lite.dao;

import com.cqc.lite.domain.Orders;
import com.cqc.lite.domain.Traveller;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface TravellerDao {

    @Select("select * from traveller where id in(select travellerId from order_traveller where orderId=#{orderId})")
    List<Traveller> findByOrdersId(String orderId)throws  Exception;
}
